Subscription Service

Data is only considered up to midnight of the previous day. This is to ensure a common cut-off date across all Data Warehouse output.

Column Heading

Unique?

Type

Length

Details

Subscription Number

Y

Numeric

8,0

CMP Subscription Number

Company Number

Y

Alphanumeric

3,0

CMP Company Number

Service Code

Y

Alphanumeric

6,0

CMP Service Code, for example, LINECH

Service Description

 

Alphanumeric

30,0

Text description of the Service Code, for example, Line Charge

Subscription Service Effective Date

Y

Numeric

25,0

The date and time from which the service is effective. YYYY-MM-DD HH:MM:SS format

Package Code

 

Alphanumeric

6,0

CMP Package Code, for example, PAYG
Package Code Description   Alphanumeric 30,0 Text description of Package Code, e.g. Pay As You Go Base Package

Recurring Charge

 

Alphanumeric

1,0

Either 1=Yes or 0=No

Price Number of Days

 

Numeric

3,0

How many days the service charge covers

Price Number of Months

 

Numeric

3,0

How many months the service charge covers

Subscription Service Expiry Date

 

Numeric

25,0

The date and time that the subscription service expires, if populated. YYYY-MM-DD HH:MM:SS format

Service Price

 

Numeric

11,2

Price to 2 decimal places, positive or negative

Invoiced Up To Date

 

Numeric

25,0

Date the service is invoiced up to. YYYY-MM-DD HH:MM:SS format .

Invoice this Service

 

Alphanumeric

1

Either 1=Yes or 0=No

Billing Offset

 

Numeric

2,0

1 = Monthly , 3 = Quarterly, 12 =Yearly, and so on

Date Time Created

 

Numeric

25,0

Date and time the record was created in CMP. YYYY-MM-DD HH:MM:SS format

Created By

 

Alphanumeric

10

User ID of user who created the record

Date Time Changed

 

Numeric

25,0

Date and time the recordwas last changed in CMP. YYYY-MM-DD HH:MM:SS format

Changed By

 

Alphanumeric

10

User ID of user who changed the record

Data Extract Date

 

Numeric

7,0

Date and time that the data above was extracted from CMP. YYYY-MM-DD format